# -*- coding: utf-8 -*-

# Define here the models for your spider middleware
#
# See documentation in:
# https://docs.scrapy.org/en/latest/topics/spider-middleware.html

import random
from scrapy import signals
from .until.Funcs import get_mysql_data
from .until.Funcs import update_data
from .until.Constant import HOST, USER, PASSWORD, DB, PORT

class SimpleProxyMiddleware(object):
    def getProxy():
        select_table = "proxy"
        select_field_list = ["ipport"]
        task_data_list = get_mysql_data(host=HOST, user=USER, password=PASSWORD, db=DB, port=PORT, table=select_table,
                                    field_list=select_field_list,size=None, filter='state =0')
        return task_data_list
     
    def delProxy(ipport):
        update_sql = "UPDATE proxy SET state = 1 WHERE ipport = %s"
        update_values_list = []
        update_values_list.append((ipport))
        update_data(host=HOST, user=USER, password=PASSWORD, db=DB, port=PORT, sql=update_sql, values_list=update_values_list)
        pass
      
    # 声明一个数组
    proxyList = getProxy();

    # Downloader Middleware的核心方法，只有实现了其中一个或多个方法才算自定义了一个Downloader Middleware
    # def process_request(self, request, spider):
    #     # 随机从其中选择一个，并去除左右两边空格
    #     proxy = ''
    #     if len(self.proxyList) > 0 : 
    #         proxy = random.choice(self.proxyList)['ipport']
    #     # 打印结果出来观察
    #     # print("this is request ip:" + proxy)
    #     # 设置request的proxy属性的内容为代理ip
    #     request.meta['proxy'] = proxy
    #     self.logger.debug("使用代理 proxy_one: %s" % proxy)

    # Downloader Middleware的核心方法，只有实现了其中一个或多个方法才算自定义了一个Downloader Middleware
    def process_response(self, request, response, spider):
        if not response.body:
            # self.logger.info('ip被屏蔽，更换代理IP...')
            proxy = ''
            if len(self.proxyList) > 0 : 
                proxy = random.choice(self.proxyList)['ipport']
                # print("this is response ip:" + proxy)
            request.meta['proxy'] = proxy
            # self.logger.debug("更换代理 proxy_one: %s" % proxy)
            return request
        if request.meta.get('dont_retry', False):
            return response
        # 请求失败不等于200
        if response.status != 200:
            # 重新选择一个代理ip
            # self.logger.debug("代理失败： %s" % request.mete['proxy'])
            proxy = ''
            if len(self.proxyList) > 0 : 
                proxy = random.choice(self.proxyList)['ipport']
                # print("this is response ip:" + proxy)
            # 设置新的代理ip内容
            # self.logger.debug("更换代理 proxy_one: %s" % proxy)
            request.meta['proxy'] = proxy
            return request
        return response

    def process_exception(self, request, exception, spider):
        if request.meta.get('dont_retry', False):
            pass
        proxy = ''
        if len(self.proxyList) > 0 : 
            proxy = random.choice(self.proxyList)['ipport']
            # print("this is response ip:" + proxy)
        request.meta['proxy'] = proxy
        # self.logger.debug("更换代理 proxy_one: %s" % proxy)
        return request
        # Called when a download handler or a process_request()
        # (from other downloader middleware) raises an exception.

        # Must either:
        # - return None: continue processing this exception
        # - return a Response object: stops process_exception() chain
        # - return a Request object: stops process_exception() chain
        pass




class JnsnewsspiderSpiderMiddleware(object):
    # Not all methods need to be defined. If a method is not defined,
    # scrapy acts as if the spider middleware does not modify the
    # passed objects.

    @classmethod
    def from_crawler(cls, crawler):
        # This method is used by Scrapy to create your spiders.
        s = cls()
        crawler.signals.connect(s.spider_opened, signal=signals.spider_opened)
        return s

    def process_spider_input(self, response, spider):
        # Called for each response that goes through the spider
        # middleware and into the spider.

        # Should return None or raise an exception.
        return None

    def process_spider_output(self, response, result, spider):
        # Called with the results returned from the Spider, after
        # it has processed the response.

        # Must return an iterable of Request, dict or Item objects.
        for i in result:
            yield i

    def process_spider_exception(self, response, exception, spider):
        # Called when a spider or process_spider_input() method
        # (from other spider middleware) raises an exception.

        # Should return either None or an iterable of Request, dict
        # or Item objects.
        pass

    def process_start_requests(self, start_requests, spider):
        # Called with the start requests of the spider, and works
        # similarly to the process_spider_output() method, except
        # that it doesn’t have a response associated.

        # Must return only requests (not items).
        for r in start_requests:
            yield r

    def spider_opened(self, spider):
        spider.logger.info('Spider opened: %s' % spider.name)


class JnsnewsspiderDownloaderMiddleware(object):
    # Not all methods need to be defined. If a method is not defined,
    # scrapy acts as if the downloader middleware does not modify the
    # passed objects.

    @classmethod
    def from_crawler(cls, crawler):
        # This method is used by Scrapy to create your spiders.
        s = cls()
        crawler.signals.connect(s.spider_opened, signal=signals.spider_opened)
        return s

    def process_request(self, request, spider):
        # Called for each request that goes through the downloader
        # middleware.

        # Must either:
        # - return None: continue processing this request
        # - or return a Response object
        # - or return a Request object
        # - or raise IgnoreRequest: process_exception() methods of
        #   installed downloader middleware will be called
        return None

    def process_response(self, request, response, spider):
        # Called with the response returned from the downloader.

        # Must either;
        # - return a Response object
        # - return a Request object
        # - or raise IgnoreRequest
        return response

    def process_exception(self, request, exception, spider):
        # Called when a download handler or a process_request()
        # (from other downloader middleware) raises an exception.

        # Must either:
        # - return None: continue processing this exception
        # - return a Response object: stops process_exception() chain
        # - return a Request object: stops process_exception() chain
        pass

    def spider_opened(self, spider):
        spider.logger.info('Spider opened: %s' % spider.name)
